#!usr/bin/env python  
# -*- coding:utf-8 _*-
""" 
@author:robot
@file: mysql01.py 
@version:
@time: 2022/01/17 
"""
from TapClientCaseData.ColumnGenerateData.dynamic.base.base00_dynamic import POSTGRES05_TYPE
from TapClientCaseData.ColumnGenerateData.dynamic.base.base00_dynamic import generate_columns_data

POSTGRES05_COLUMNS = POSTGRES05_TYPE.get('COLUMNS')

BASE = POSTGRES05_COLUMNS.get('BASE')
PK = BASE.get('PK').lower()
NO_PK = BASE.get('NO PK').lower()

# ****NUMERIC****
NUMERIC = POSTGRES05_COLUMNS.get('NUMERIC')

# ****MONETARY****
MONETARY = POSTGRES05_COLUMNS.get('MONETARY')

# ****CHARACTER****
CHARACTER = POSTGRES05_COLUMNS.get('CHARACTER')

# ****BINARY_DATA*****
BINARY_DATA = POSTGRES05_COLUMNS.get('BINARY_DATA')

# ****DATE_TIME****
DATE_TIME = POSTGRES05_COLUMNS.get('DATE_TIME')

# ****BOOLEAN****
BOOLEAN = POSTGRES05_COLUMNS.get('BOOLEAN')

# ****ENUMRATED****
ENUMERATED = POSTGRES05_COLUMNS.get('ENUMERATED')

# ****GEOMETRIC*****
GEOMETRIC = POSTGRES05_COLUMNS.get('GEOMETRIC')

# ****NETWORK_ADDRESS****
NETWORK_ADDRESS = POSTGRES05_COLUMNS.get('NETWORK_ADDRESS')

# ****BIT****
BIT = POSTGRES05_COLUMNS.get('BIT')

# ****TEXT****
TEXT = POSTGRES05_COLUMNS.get('TEXT')

# ****UUID****
UUID = POSTGRES05_COLUMNS.get('UUID')

# ****XML****
XML = POSTGRES05_COLUMNS.get('XML')

# ****JSON****
JSON = POSTGRES05_COLUMNS.get('JSON')

# ****ARRAYS****
ARRAYS = POSTGRES05_COLUMNS.get('ARRAYS')

# ****COMPOSITE****
COMPOSITE = POSTGRES05_COLUMNS.get('COMPOSITE')

# ****RANGE****
RANGE = POSTGRES05_COLUMNS.get('RANGE')

# ****DOMAIN****
DOMAIN = POSTGRES05_COLUMNS.get('DOMAIN')

# ****OBJECT_IDENTIFIER****
OBJECT_IDENTIFIER = POSTGRES05_COLUMNS.get('OBJECT_IDENTIFIER')

# ****PG_LSN****
PG_LSN = POSTGRES05_COLUMNS.get('PG_LSN')

# --NUMERIC--
smallint = NUMERIC.get('smallint').get('CREATE')
integer = NUMERIC.get('integer').get('CREATE')
bigint = NUMERIC.get('bigint').get('CREATE')
int2 = NUMERIC.get('int2').get('CREATE')
int4 = NUMERIC.get('int4').get('CREATE')
int8 = NUMERIC.get('int8').get('CREATE')
decimal = NUMERIC.get('decimal').get('CREATE')
numeric = NUMERIC.get('numeric').get('CREATE')
real = NUMERIC.get('real').get('CREATE')
double_precision = NUMERIC.get('double precision').get('CREATE')
smallserial = NUMERIC.get('smallserial').get('CREATE')
serial = NUMERIC.get('serial').get('CREATE')
bigserial = NUMERIC.get('bigserial').get('CREATE')

# --MONETARY--
money = MONETARY.get('money').get('CREATE')

# --CHARACTER--
character_varying = CHARACTER.get('character_varying').get('CREATE')
varchar = CHARACTER.get('varchar').get('CREATE')
character = CHARACTER.get('character').get('CREATE')
char = CHARACTER.get('char').get('CREATE')
text = CHARACTER.get('text').get('CREATE')

# --BINARY_DATA--
bytea = BINARY_DATA.get('bytea').get('CREATE')

# --DATE_TIME--
timestamp = DATE_TIME.get('timestamp').get('CREATE')
timestamp_with_time_zone = DATE_TIME.get('timestamp with time zone').get('CREATE')
date = DATE_TIME.get('date').get('CREATE')
time = DATE_TIME.get('time').get('CREATE')
time_with_time_zone = DATE_TIME.get('time with time zone').get('CREATE')
interval = DATE_TIME.get('interval').get('CREATE')

# --BOOLEAN--
boolean = BOOLEAN.get('boolean').get('CREATE')

# --ENUMRATED--
enumerate_sample = ENUMERATED.get('sample')
enum = ENUMERATED.get('ENUM')

# --GEOMETRIC--
points = GEOMETRIC.get('points')
lines = GEOMETRIC.get('lines')
line_segments = GEOMETRIC.get('line segments')
boxes = GEOMETRIC.get('boxes')
path = GEOMETRIC.get('path')
polygons = GEOMETRIC.get('polygons')
circles = GEOMETRIC.get('circles')

# --NETWORK_ADDRESS--
cidr = NETWORK_ADDRESS.get('cidr').get('CREATE')
inet = NETWORK_ADDRESS.get('inet').get('CREATE')
macaddr = NETWORK_ADDRESS.get('macaddr').get('CREATE')
macaddr8 = NETWORK_ADDRESS.get('macaddr8').get('CREATE')

# --BIT--
bit = BIT.get('bit').get('CREATE')
bit_varying = BIT.get('bit_varying').get('CREATE')

# --TEXT--
# text = TEXT.get('text')

# --UUID--
uuid = UUID.get('uuid').get('CREATE')

# --XML--
xml = XML.get('xml').get('CREATE')

# --JSON--
json_ = JSON.get('json').get('CREATE')
jsonb = JSON.get('jsonb').get('CREATE')

# --ARRAYS--
array_one = ARRAYS.get('array_one').get('CREATE')
array_two = ARRAYS.get('array_two').get('CREATE')

# --COMPOSITE--
composite_sample = COMPOSITE.get('TYPE')
inventory_item = COMPOSITE.get('inventory_item')

# --RANGE--
int4range = RANGE.get('int4range').get('CREATE')
int8range = RANGE.get('int8range').get('CREATE')
numrange = RANGE.get('numrange').get('CREATE')
tsrange = RANGE.get('tsrange').get('CREATE')
tstzrange = RANGE.get('tstzrange').get('CREATE')
daterange = RANGE.get('daterange').get('CREATE')

# --DOMAIN--
posint_sample = DOMAIN.get('sample')
posint = DOMAIN.get('posint')

# --OBJECT_IDENTIFIER--
oid = OBJECT_IDENTIFIER.get('oid')
regproc = OBJECT_IDENTIFIER.get('regproc')
regprocedure = OBJECT_IDENTIFIER.get('regprocedure')
regoper = OBJECT_IDENTIFIER.get('regoper')
regoperator = OBJECT_IDENTIFIER.get('regoperator')
regclass = OBJECT_IDENTIFIER.get('regclass')
regtype = OBJECT_IDENTIFIER.get('regtype')
regrole = OBJECT_IDENTIFIER.get('regrole')
regnamespace = OBJECT_IDENTIFIER.get('regnamespace')
regconfig = OBJECT_IDENTIFIER.get('regconfig')
regdictionary = OBJECT_IDENTIFIER.get('regdictionary')

# --PG_LSN--
pg_lsn = PG_LSN.get('pg_lsn')
